﻿<?xml version="1.0" encoding="utf-8" ?>
<AdoNetDataAccess connection="$UserLoginDBConnection$" formatter="bizobj of User(groups)">
  <Sql>
    SELECT
      u.id, userName as useruserName, password, password as password2, companyId, 
	  membershipExpires, enable,l.groupId as groupsid
    FROM 
		Users u
	LEFT JOIN 
		UserGroupLink l ON u.id = l.userId 		
    WHERE
      u.id=@userId
  </Sql>
  <Param name="userId" type="UniqueIdentifier"/>
</AdoNetDataAccess>